package cn.lili.modules.wallet.mapper;


import cn.lili.common.vo.PageVO;
import cn.lili.modules.wallet.entity.dos.MemberWithdrawApply;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.poi.ss.formula.functions.T;

/**
 * 会员提现申请数据处理层
 *
 * @author pikachu
 * @since 2020-02-25 14:10:16
 */
public interface MemberWithdrawApplyMapper extends BaseMapper<MemberWithdrawApply> {

    @Select("SELECT a.*,p.partner_type from li_member_withdraw_apply a "
            + "left join li_partner p on p.member_id = a.member_id and p.partner_state = 0 and p.delete_flag = 0 ${ew.customSqlSegment}")
    IPage<MemberWithdrawApply> selectPage(PageVO page, @Param("ew") Wrapper<MemberWithdrawApply> queryWrapper);
}